-- @owner: @songjing20
-- @date: 2022/7/4
-- @testpoint: 测试create index concurrently关键字在事务内创建哈希索引,部分测试点合理报错

--step1:创建表;expect:成功
drop table if exists t_hash_index_0051;
create table t_hash_index_0051(id01 int, id02 char(20)) with (orientation = row);

--step2:创建哈希索引(事务内运行);expect:合理报错
begin;/
create index concurrently i_hash_index_0051 on t_hash_index_0051 using hash(id01);
commit;

--step3:创建哈希索引(事务外运行);expect:成功
create index concurrently i_hash_index_0051 on t_hash_index_0051 using hash(id01);

--step4:清理环境;expect:成功
drop table t_hash_index_0051 cascade;